Stored Procedures [dbo].[BAEOrderSuperProductAttributeValueInsert]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@OrderSuperProductAttributeIDint4
@Titlevarchar(128)128
@SortOrderint4
SQL Script
create procedure [dbo].[BAEOrderSuperProductAttributeValueInsert] @OrderSuperProductAttributeID as
int,
    @Title AS varchar(128),
    @SortOrder AS int
AS
    INSERT INTO OrderSuperProductAttributeValue
    (    
    OrderSuperProductAttributeID,            
    Title,            
    SortOrder        
    )
    VALUES
    (    
    @OrderSuperProductAttributeID,            
    @Title,            
    @SortOrder                                                                
    );

    SELECT CAST(@@IDENTITY AS int) AS 'InsertedOrderSuperProductAttributeValue';

GO
Uses